[dbo].[BadAddressReasonRef]

Property	Value
Created	10:31:14 AM Tuesday, March 02, 2010
Last Modified	11:40:00 AM Monday, February 20, 2012

Property

Value

Created

10:31:14 AM Tuesday, March 02, 2010

Last Modified

11:40:00 AM Monday, February 20, 2012

Name	Data Type	Max Length (Bytes)
BadAddressReasonKey	uniqueidentifier	16
BadAddressReasonDesc	nvarchar(100)	200
ErrorCode	nvarchar(20)	40
ErrorMessage	nvarchar(1000)	2000
IsSystem	bit	1
IsPhysical	bit	1

Name

Data Type

Max Length (Bytes)

Allow Nulls

BadAddressReasonKey

uniqueidentifier

BadAddressReasonDesc

nvarchar(100)

200

ErrorCode

nvarchar(20)

ErrorMessage

nvarchar(1000)

2000

IsSystem

bit

IsPhysical

bit

	Name	Columns	Unique
	PK_BadAddressReasonRef	BadAddressReasonKey

Name

Columns

Unique

PK_BadAddressReasonRef

BadAddressReasonKey

SQL Script

CREATE TABLE [dbo].[BadAddressReasonRef]
(
[BadAddressReasonKey] [uniqueidentifier] NOT NULL,
[BadAddressReasonDesc] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ErrorCode] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ErrorMessage] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsSystem] [bit] NOT NULL,
[IsPhysical] [bit] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[BadAddressReasonRef] ADD CONSTRAINT [PK_BadAddressReasonRef] PRIMARY KEY CLUSTERED ([BadAddressReasonKey]) ON [PRIMARY]
GO